Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$OBJECT_USAGE

You can use this view to monitor index usage. The view displays statistics about index usage gathered from the database. All indexes that have been used at least once can be monitored and displayed in this view.

Column | Datatype | Description
--- | --- | ---
`INDEX_NAME` | `VARCHAR2(30)` | Index name in sys.obj$.name
`TABLE_NAME` | `VARCHAR2(30)` | Table name in sys.obj$.name
`MONITORING` | `VARCHAR2(3)` | `YES`| `NO`
`USED` | `VARCHAR2(3)` | `YES`| `NO`
`START_MONITORING` | `VARCHAR2(19)` | Start monitoring time in `sys.object_stats.start_monitoring`
`END_MONITORING` | `VARCHAR2(19)` | End monitoring time in `sys.object_stats.end_monitoring`